{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Selvbudgettering","Bilag 1 ","Bilag 2 ","Bilag 3","Makro mv."],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":19,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Selvbudgettering","index":0,"n_rows":305,"n_cols":10,"rows_kept":305,"cut":false,"hidden":false,"merged":[[171,1,171,7],[172,1,172,7],[62,1,62,7],[4,3,4,5]]}
[null,{"$f":"\"Selvbudgettering af tilskud og udligning \"&aar","v":"Selvbudgettering af tilskud og udligning 2025"}]
[null," "]
[null,null,"Indtast eget kommunenummer her :"]
[null,null,null," "]
[null,null,"Kommune:",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,2),\"Ugyldigt kommunenr. \")","v":"Ugyldigt kommunenr. "}]
[null,null,"Indtast kommunens budgettal i Tabel 1 cellerne: F24, F25 og F28"]
[]
[]
[]
[]
[null,null,null,{"$f":"\"Indenrigs-og Sundhedsministeriet \"","v":"Indenrigs-og Sundhedsministeriet "}]
[null,null,null,{"$f":"\"Selvbudgettering af tilskud og udligning \"&aar","v":"Selvbudgettering af tilskud og udligning 2025"}]
[null,null,null,{"$f":"\"for  (\"&TEXT(knr,0)&\")  \"&$D$5","v":"for  (0)  Ugyldigt kommunenr. "}]
[]
[null,null,null,{"$f":"\"Indenrigs-og Sundhedsministeriet \"","v":"Indenrigs-og Sundhedsministeriet "}]
[null,null,null,"Slotsholmsgade 10-12"]
[null,null,null,"1216 København K"]
[]
[]
[]
[null,{"$f":"\"Tabel 1:  Budgetteringsforudsætninger  (\"&TEXT(knr,0)&\")  \"&$D$5","v":"Tabel 1:  Budgetteringsforudsætninger  (0)  Ugyldigt kommunenr. "}]
[null,null,null,null,null,"Egen"]
[null,null,null,null,null,"beregning"]
[null,{"$f":"\"1.01 Indkomstskat  \"&aar","v":"1.01 Indkomstskat  2025"}]
[null,{"$f":"\"1.02 Udskrivningsprocent \"&aar&\"  (xx,xx)\"","v":"1.02 Udskrivningsprocent 2025  (xx,xx)"}]
[null,{"$f":"\"1.03 Beregningsteknisk grundværdier vedr. øvrige ejendomme \"&aar","v":"1.03 Beregningsteknisk grundværdier vedr. øvrige ejendomme 2025"},null,null,null,{"$f":"+H183","v":"---------- "}]
[null,{"$f":"\"1.04 Beregningsteknisk grundværdier vedr. produktionsjord \"&aar","v":"1.04 Beregningsteknisk grundværdier vedr. produktionsjord 2025"},null,null,null,{"$f":"+H185","v":"---------- "}]
[null,{"$f":"\"1.05 Skønnet folketal pr. 1. januar \"&aar","v":"1.05 Skønnet folketal pr. 1. januar 2025"}]
[null,"Anm. pkt. 1.05 Bopælskommuneopgørelse"]
[null,null,null,null,null,null,"1.01, 1.02 og 1.05 indberettes til"]
[null,null,null,null,null,null,"Indenrigs-  og Sundhedsministeriet"]
[null,null,null,null,null,null,"på www.indtast.dk,i skemaet vedr."]
[null,null,null,null,null,null,"skatteoplysninger og valg af bud-"]
[null,null,null,null,null,null,"getteringsmetode i forbindelse "]
[null,null,null,null,null,null,{"$f":"+\"med budgetindberetningen for \"&aar","v":"med budgetindberetningen for 2025"}]
[]
[null,{"$f":"\"Tabel 2: Selvbudgetterede udligningsbeløb vedr. \"&aar","v":"Tabel 2: Selvbudgetterede udligningsbeløb vedr. 2025"}]
[null,null,null,null,null,"Egen","Stats-","Forskel"]
[null,null,"Beløb i 1.000 kr. (+ = tilskud/ indtægt)",null,null,"beregning","garanti","(1)-(2)"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[]
[null,"7.62.80 grp. 001 Kommunal udligning"]
[null,null,"Udligning af beskatningsgrundlag (jf. B.08)",null,null,{"$f":"IF(ok_pp=1,+G205,\" \")","v":" "},{"$f":"IF(OK_P=1,+H205,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F43-G43,\" \")","v":" "}]
[null,null,"Tillæg for kommuner med lavt beskatningsgrundlag (jf. C.08)",null,null,{"$f":"IF(ok_pp=1,+G221,\" \")","v":" "},{"$f":"IF(OK_P=1,+H221,\"---------- \")","v":"---------- "}," "]
[null,null,"Tillæg for kommuner med højt beskatningsgrundlag (jf. D.08)",null,null,{"$f":"IF(ok_pp=1,+G237,\" \")","v":" "},{"$f":"IF(OK_P=1,+H237,\"---------- \")","v":"---------- "}," "]
[null,null,"Finansieringsandel af tillæg vedr. beskatningsgrundlag (jf. G.16)",null,null,{"$f":"IF(ok_pp=1,+G293,\" \")","v":" "},{"$f":"IF(OK_P=1,+H293,\"---------- \")","v":"---------- "}," "]
[null,null,"Korr. vedr. overudligning (jf. G.15)",null,null,{"$f":"IF(ok_pp=1,+G292,\" \")","v":" "},{"$f":"IF(OK_P=1,+H292,\"---------- \")","v":"---------- "}," "]
[null,null,"Udligning af udgiftsbehov (jf E.07)",null,null,{"$f":"IF(ok_pp=1,+G252,\" \")","v":" "},{"$f":"IF(OK_P=1,+H252,\"---------- \")","v":"---------- "}," "]
[null,null,"Tillæg for kommuner med højt udgiftsbehov (jf. F.07)",null,null,{"$f":"IF(ok_pp=1,+G267,\" \")","v":" "},{"$f":"IF(OK_P=1,+H267,\"---------- \")","v":"---------- "}," "]
[null,null,"Finansieringsandel af tillæg vedr. udgiftsbehov (jf. G.17)",null,null,{"$f":"IF(ok_pp=1,+G294,\" \")","v":" "},{"$f":"IF(OK_P=1,+H294,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F50-G50,\" \")","v":" "}]
[]
[null,"7.62.80 grp. 002 Statstilskud til kommuner"]
[null,null,"Statstilskud, ordinært  til kommuner (jf. G.11)",null,null,{"$f":"IF(ok_pp=1,+G288,\" \")","v":" "},{"$f":"IF(OK_P=1,+H288,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F53-G53,\" \")","v":" "}]
[null,null,"Statstilskud, betinget vedr. service (jf. G.12)",null,null,{"$f":"IF(ok_pp=1,+G289,\" \")","v":" "},{"$f":"IF(OK_P=1,+H289,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F54-G54,\" \")","v":" "}]
[null,null,"Statstilskud, betinget vedr. anlæg (jf. G.13)",null,null,{"$f":"IF(ok_pp=1,+G290,\" \")","v":" "},{"$f":"IF(OK_P=1,+H290,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F55-G55,\" \")","v":" "}]
[]
[null,"7.62.81 grp. 001 Udligning vedr. udlændinge "]
[null,null,"Samlet bidrag vedr. indv. og efterkommere (jf. G.14)",null,null,{"$f":"IF(ok_pp=1,+G291,\" \")","v":" "},{"$f":"IF(OK_P=1,+H291,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F58-G58,\" \")","v":" "}]
[]
[null,"Selvbudgetterede beløb i alt",null,null,null,{"$f":"IF(ok_pp=1,SUM(F43:F58),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G43:G58),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,SUM(H43:H59),\" \")","v":" "}]
[]
[]
[]
[null,{"$f":"\"TABEL 3: Konteringsoversigt \"&aar&\" (del I)  for:   (\"&TEXT(knr,0)&\")  \"&$D$5","v":"TABEL 3: Konteringsoversigt 2025 (del I)  for:   (0)  Ugyldigt kommunenr. "}]
[null,null,null,null,null,"Egen","Stats-","Forskel"]
[null,null,"Beløb i 1.000 kr. (+ = tilskud/ indtægt)",null,null,"beregning","garanti","(1)-(2)"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[]
[null,"2.32.33 Færgedrift",null,null,null,{"$f":"IF(ok_pp=1,SUM(F70:F74),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G70:G74),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F69-G69,\" \")","v":" "}]
[null,null,"Tilskud til nedsat færgetakst for godstransport",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,37),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,37),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F70-G70,\" \")","v":" "}]
[null,null,"Tilskud til nedsat færgetakst for passagerbefordring",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,38),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,38),\"---------- \")","v":"---------- "}," "]
[null,null,"Momskompensation vedr. færgetakster for godstransport",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,39),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,39),\"---------- \")","v":"---------- "}," "]
[null,null,"Momskompensation vedr. færgetakster for passagerer",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,40),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,40),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til færgedrift",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,41),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,41),\"---------- \")","v":"---------- "}," "]
[null,"2.32.33 I alt",null,null,null,{"$f":"IF(ok_pp=1,+F69,\" \")","v":" "},{"$f":"IF(OK_P=1,+G69,\"---------- \")","v":"---------- "}," "]
[]
[]
[null,null,null,null,null,"Egen","Stats-","Forskel"]
[null,null,"Beløb i 1.000 kr. (+ = tilskud/ indtægt)",null,null,"beregning","garanti","(1)-(2)"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[]
[null,"7.62.80 grp. 001 Kommunal udligning",null,null,null,{"$f":"IF(ok_pp=1,SUM(F83:F92),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G83:G92),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F82-G82,\" \")","v":" "}]
[null,null,"Udligning af beskatningsgrundlag (jf. B.08)",null,null,{"$f":"IF(ok_pp=1,+G205,\" \")","v":" "},{"$f":"IF(OK_P=1,+H205,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F83-G83,\" \")","v":" "}]
[null,null,"Tillæg for kommuner med lavt beskatningsgrundlag (jf. C.08)",null,null,{"$f":"IF(ok_pp=1,+G221,\" \")","v":" "},{"$f":"IF(OK_P=1,+H221,\"---------- \")","v":"---------- "}," "]
[null,null,"Tillæg for kommuner med højt beskatningsgrundlag (jf. D.08)",null,null,{"$f":"IF(ok_pp=1,+G237,\" \")","v":" "},{"$f":"IF(OK_P=1,+H237,\"---------- \")","v":"---------- "}," "]
[null,null,"Finansieringsandel af tillæg vedr. beskatningsgrundlag (jf. G.16)",null,null,{"$f":"IF(ok_pp=1,+G293,\" \")","v":" "},{"$f":"IF(OK_P=1,+H293,\"---------- \")","v":"---------- "}," "]
[null,null,"Overudligning",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,7),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,7),\"---------- \")","v":"---------- "}," "]
[null,null,"Korr. vedr. overudligning (jf. G.15)",null,null,{"$f":"IF(ok_pp=1,+G292,\" \")","v":" "},{"$f":"IF(OK_P=1,+H292,\"---------- \")","v":"---------- "}," "]
[null,null,"Udligning af udgiftsbehov (jf E.07)",null,null,{"$f":"IF(ok_pp=1,+G252,\" \")","v":" "},{"$f":"IF(OK_P=1,+H252,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F89-G89,\" \")","v":" "}]
[null,null,"Tillæg for kommuner med højt udgiftsbehov (jf. F.07)",null,null,{"$f":"IF(ok_pp=1,+G267,\" \")","v":" "},{"$f":"IF(OK_P=1,+H267,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F90-G90,\" \")","v":" "}]
[null,null,"Finansieringsandel af tillæg vedr. udgiftsbehov (jf. G.17)",null,null,{"$f":"IF(ok_pp=1,+G294,\" \")","v":" "},{"$f":"IF(OK_P=1,+H294,\"---------- \")","v":"---------- "}," "]
[null,null,"Særlig kompensation",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,12),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,12),\"---------- \")","v":"---------- "}," "]
[null,"7.62.80 grp. 002 Statstilskud til kommuner ",null,null,null,{"$f":"IF(ok_pp=1,SUM(F94:F99),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G94:G99),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F93-G93,\" \")","v":" "}]
[null,null,{"$f":"+\"Bloktilskud ordinært vedr. \"&aar&\" (jf. G.11)\"","v":"Bloktilskud ordinært vedr. 2025 (jf. G.11)"},null,null,{"$f":"IF(ok_pp=1,+G288,\" \")","v":" "},{"$f":"IF(OK_P=1,+H288,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F94-G94,\" \")","v":" "}]
[null,null,{"$f":"+\"Bloktilskud betinget vedr. service \"&aar&\" (jf. G.12)\"","v":"Bloktilskud betinget vedr. service 2025 (jf. G.12)"},null,null,{"$f":"IF(ok_pp=1,+G289,\" \")","v":" "},{"$f":"IF(OK_P=1,+H289,\"---------- \")","v":"---------- "}," "]
[null,null,{"$f":"+\"Bloktilskud betinget vedr. anlæg \"&aar&\" (jf. G.13)\"","v":"Bloktilskud betinget vedr. anlæg 2025 (jf. G.13)"},null,null,{"$f":"IF(ok_pp=1,+G290,\" \")","v":" "},{"$f":"IF(OK_P=1,+H290,\"---------- \")","v":"---------- "}," "]
[null,null,"Individuelt modregning sfa. skattestigninger 2021 til 2022 ",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,50),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,50),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F97-G97,\" \")","v":" "}]
[null,null,"Individuelt modregning sfa. skattestigninger 2022 til 2023 ",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,51),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,51),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F98-G98,\" \")","v":" "}]
[null,null,"Individuelt modregning sfa. skattestigninger 2023 til 2024 ",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,52),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,52),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F99-G99,\" \")","v":" "}]
[null,{"$f":"+\"7.62.80 grp. 010 Udligning af selskabsskat\"","v":"7.62.80 grp. 010 Udligning af selskabsskat"},null,null,null,{"$f":"IF(ok_pp=1,SUM(F101:F101),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G101:G101),\" ---------- \")","v":" ---------- "}," "]
[null,null,{"$f":"+\"Udligning af selskabsskat\"","v":"Udligning af selskabsskat"},null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,15),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,15),\"---------- \")","v":"---------- "}," "]
[null,{"$f":"+\"7.62.80 grp. 011 Udligning af dækningsafgifter (offentlige ejendomme)\"","v":"7.62.80 grp. 011 Udligning af dækningsafgifter (offentlige ejendomme)"},null,null,null,{"$f":"IF(ok_pp=1,SUM(F103:F103),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G103:G103),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F102-G102,\" \")","v":" "}]
[null,null,{"$f":"+\"Udligning af dækningsafgift af offentlige ejendomme\"","v":"Udligning af dækningsafgift af offentlige ejendomme"},null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,16),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,16),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F103-G103,\" \")","v":" "}]
[null,"7.62.80 I alt",null,null,null,{"$f":"IF(ok_pp=1,+F82+F93+F100+F102,\" \")","v":" "},{"$f":"IF(OK_P=1,+G82+G93+G100+G102,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F118-G118,\" \")","v":" "}]
[]
[]
[null,null,null,null,null,"Egen","Stats-","Forskel"]
[null,null,"Beløb i 1.000 kr. (+ = tilskud/ indtægt)",null,null,"beregning","garanti","(1)-(2)"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[]
[null,"7.62.81 grp. 001 Udligning vedr. udlændinge i alt",null,null,null,{"$f":"IF(ok_pp=1,SUM(F112:F113),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G112:G113),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F111-G111,\" \")","v":" "}]
[null,null,"Samlet tilskud vedr. indvandrer og efterkommere",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,13),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,13),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F112-G112,\" \")","v":" "}]
[null,null,"Samlet bidrag vedr. indv. og efterkommere (jf. G.14)",null,null,{"$f":"IF(ok_pp=1,+G291,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,14),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F113-G113,\" \")","v":" "}]
[null,"7.61.81 I alt",null,null,null,{"$f":"IF(ok_pp=1,F111,\" \")","v":" "},{"$f":"IF(OK_P=1,G111,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F114-G114,\" \")","v":" "}]
[]
[]
[]
[]
[]
[null,{"$f":"\"TABEL 3: Konteringsoversigt \"&aar&\" (del II)  for:   (\"&TEXT(knr,0)&\")  \"&$D$5","v":"TABEL 3: Konteringsoversigt 2025 (del II)  for:   (0)  Ugyldigt kommunenr. "}]
[]
[null,null,null,null,null,"Egen","Stats-","Forskel"]
[null,null,"Beløb i 1.000 kr. (+ = tilskud/ indtægt)",null,null,"beregning","garanti","(1)-(2)"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[]
[null,"7.62.86 grp. 001 Tilskud til vanskeligt stillede kommuner",null,null,null,{"$f":"IF(ok_pp=1,SUM(F127:F127),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G127:G127),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F126-G126,\" \")","v":" "}]
[null,null,"Tilskud til vanskeligt stillede kommuner",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,32),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,32),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 002 Tilskud til Furesø Kommune",null,null,null,{"$f":"IF(ok_pp=1,SUM(F129:F129),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G129:G129),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til Furesø Kommune",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,31),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,31),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 004 Tilskud til Ø-kommuner",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F131:F132),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G131:G132),\" ---------- \")","v":" ---------- "}," "]
[null,null,"Tilskud til kommuner med mindre øer",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,35),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,35),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til kommuner på øer uden fast forbindelse",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,36),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,36),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 013 Tilskud til bedre kvalitet i dagtilbud",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F134:F134),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G134:G134),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F133-G133,\" \")","v":" "}]
[null,null,"Tilskud til bedre kvalitet i dagtilbud",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,21),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,21),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 014 Tilskud til generelt løft af ældreplejen",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F136:F136),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G136:G136),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til generelt løft af ældreplejen",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,22),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,22),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 015 Tilskud til styrket kvalitet i ældreplejen",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F138:F138),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G138:G138),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til styrket kvalitet i ældreplejen",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,23),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,23),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 019 Finansieringstilskud (Tilskud til styrkelse af kom. Likviditet)",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F140:F140),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G140:G140),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+SUM(H140:H140),\" \")","v":" "}]
[null,null,"Tilskud til styrkelse af kommunernes likviditet",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,20),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,20),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F140-G140,\" \")","v":" "}]
[null,"7.62.86 grp. 021 Individuelt tilskud vedr. skattenedsættelser ",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F142:F148),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G142:G148),\" ---------- \")","v":" ---------- "}," "]
[null,null,"Tilskud vedr. skattenedsættelse 2021-2022 (økonomiaftale)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,43),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,43),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud vedr. skattenedsættelse 2022-2023 (økonomiaftale)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,44),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,44),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud vedr. skattenedsættelse 2020-2021 (udligningsreform)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,45),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,45),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F144-G144,\" \")","v":" "}]
[null,null,"Tilskud vedr. skattenedsættelse 2021-2022 (udligningsreform)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,46),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,46),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F145-G145,\" \")","v":" "}]
[null,null,"Tilskud vedr. skattenedsættelse 2022-2023 (udligningsreform)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,47),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,47),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud vedr. skattenedsættelse 2023-2024 (udligningsreform)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,48),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,48),\"---------- \")","v":"---------- "}]
[null,null,"Permanent tilskud vedr. skattenedsættelse 2020-2021 (udligningsreform)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,49),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,49),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F148-G148,\" \")","v":" "}]
[null,"7.62.86 grp. 022 Tilskud til kommuner med vanskelige vilkår",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F150:F150),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G150:G150),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til kommuner med vanskelige økonomiske vilkår",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,33),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,33),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 025 Tilskud til værdig ældrepleje",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F152:F152),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G152:G152),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F151-G151,\" \")","v":" "}]
[null,null,"Tilskud til værdig ældrepleje",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,24),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,24),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F152-G152,\" \")","v":" "}]
[null,"7.62.86 grp. 026 Tilskud til bekæmpelse af ensomhed",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F154:F154),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G154:G154),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F153-G153,\" \")","v":" "}]
[null,null,"Tilskud til bekæmpelse af ensomhed",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,25),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,25),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F154-G154,\" \")","v":" "}]
[null,"7.62.86 grp. 027 Tilskud til udsatte ø- og yder kommuner",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F156:F156),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G156:G156),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F155-G155,\" \")","v":" "}]
[null,null,"Tilskud til udsatte ø- og yderkommuner",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,26),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,26),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F156-G156,\" \")","v":" "}]
[null,"7.62.86 grp. 028 Tilskud til udsatte hovedstadskommuner",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F158:F159),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G158:G159),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til udsatte hovedstadskommuner",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,27),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,27),\" ---------- \")","v":" ---------- "}," "]
[null,null,"Bidrag vedr. udsatte hovedstadskommuner",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,28),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,28),\" ---------- \")","v":" ---------- "}," "]
[null,"7.62.86 grp. 029 Tilskud til grænsenære kommuner",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F161:F161),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G161:G161),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til grænsenære kommuner",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,29),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,29),\" ---------- \")","v":" ---------- "}," "]
[null,"7.62.86 grp. 030 Tilskud vedr. høj kriminalitet i visse boligområder",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F163:F163),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G163:G163),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud vedr. høj kriminalitet i visse boligområder",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,30),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,30),\" ---------- \")","v":" ---------- "}," "]
[null,"7.62.86 ",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F165:F165),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G165:G165),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F164-G164,\" \")","v":" "}]
[null,null,"Kompensationstilskud vedr. nettotab sfa. ændring i dækningsafgiften",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,34),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,34),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F165-G165,\" \")","v":" "}]
[null,"7.62.86 I alt",null,null,null,{"$f":"IF(ok_pp=1,+F126+F128+F130+F133+F137+F135+F149+F139+F141+F153+F151+F155+F157+F160+F162+F164,\" \")","v":" "},{"$f":"IF(OK_P=1,+G126+G128+G130+G133+G137+G135+G149+G139+G141+G153+G151+G155+G157+G160+G162+G164,\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F166-G166,\" \")","v":" "}]
[]
[null,{"$f":"+\"7.62.80, 7.62.81 og 7.62.86 I alt, til afregning i \"&aar&\" (del I + del II)\"","v":"7.62.80, 7.62.81 og 7.62.86 I alt, til afregning i 2025 (del I + del II)"},null,null,null,{"$f":"IF(ok_pp=1,+F75++F104+F114+F166,\" \")","v":" "},{"$f":"IF(OK_P=1,+G75+G104+G114+G166,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F168-G168,\" \")","v":" "}]
[]
[]
[]
[null,"Beregningsvejledning"]
[]
[]
[null,{"$f":"\"Bilag A:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag A:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Beregningsvejledning til opgørelse af kommunens beskatningsgrundlag \"&aar","v":"Beregningsvejledning til opgørelse af kommunens beskatningsgrundlag 2025"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"A.01 Indkomstskat (jf. pkt 1.01)\"","v":"A.01 Indkomstskat (jf. pkt 1.01)"},null,null,null,null,{"$f":"IF(ok_pp=1,+F24,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,4),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.02 Udskrivningsprocent \"&aar&\" (jf. pkt 1.02)\"","v":"A.02 Udskrivningsprocent 2025 (jf. pkt 1.02)"},null,null,null,null,{"$f":"IF(ok_pp=1,F25,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,3),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.03 Udskrivningsgrundlag \"&aar&\" (pkt. A.01/A.02) \"","v":"A.03 Udskrivningsgrundlag 2025 (pkt. A.01/A.02) "},null,null,null,null,{"$f":"IF(ok_pp=1,ROUND(+F24/(F25/100),0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,5),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.04a Beregningsteknisk grundværdier vedr. øvrige ejendomme jf. pkt 1.03\"","v":"A.04a Beregningsteknisk grundværdier vedr. øvrige ejendomme jf. pkt 1.03"},null,null,null,null,{"$f":"IF(ok_pp=1,F26,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,9),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.04b \"&TEXT(100*'Bilag 3'!D19,\"0,00\")&\" % af beregningstekniske grundværdier vedr. øvrige ejendomme (jf. A.04a)\"","v":"A.04b 10,06 % af beregningstekniske grundværdier vedr. øvrige ejendomme (jf. A.04a)"},null,null,null,null,{"$f":"IF(ok_pp=1,ROUND(('Bilag 3'!D19)*F26,0),\" \")","v":" "},{"$f":"IF(OK_P=1,  ROUND(('Bilag 3'!D19)*(VLOOKUP(knr,Bilagtab2,9)),0),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.05a Beregningsteknisk grundværdier vedr. produktionsjord. pkt 1.04\"","v":"A.05a Beregningsteknisk grundværdier vedr. produktionsjord. pkt 1.04"},null,null,null,null,{"$f":"IF(ok_pp=1,F27,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,10),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.05b \"&TEXT(100*'Bilag 3'!D17,\" 0,00\")&\" % af beregningstekniske grundværdier vedr. produktionsjord (jf. A.05a)\"","v":"A.05b  3,08 % af beregningstekniske grundværdier vedr. produktionsjord (jf. A.05a)"},null,null,null,null,{"$f":"IF(ok_pp=1,ROUND(('Bilag 3'!D17)*F27,0),\" \")","v":" "},{"$f":"IF(OK_P=1,  ROUND(('Bilag 3'!D17)*(VLOOKUP(knr,Bilagtab2,10)),0),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.06 Beskatningsgrundlag \"&aar&\" i 1.000 kr.  (A.03 + A.04b + A.05b)\"","v":"A.06 Beskatningsgrundlag 2025 i 1.000 kr.  (A.03 + A.04b + A.05b)"},null,null,null,null,{"$f":"IF(ok_pp=1,+G182+G184+G186,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,11),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.07 Folketal (jf. pkt. 1.05)\"","v":"A.07 Folketal (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.08 Beskatningsgrundlag i kr. pr. indb.  (A.06 / A.07)\"","v":"A.08 Beskatningsgrundlag i kr. pr. indb.  (A.06 / A.07)"},null,null,null,null,{"$f":"IF(ok_pp=1,G187/F28,\" \")","v":" "},{"$f":"IF(OK_P=1,H187/H188,\"---------- \")","v":"---------- "}]
[null,"Anm: A.03, A.04b og A.05b afrundes til nærmeste hele 1.000 kr.  Pkt. A.08 indgår uafrundet i udligningsberegningerne"]
[]
[]
[null,{"$f":"\"Bilag B:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag B:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Udligning af beskatningsgrundlag \"&aar","v":"Udligning af beskatningsgrundlag 2025"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"B.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08\"","v":"B.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08"},null,null,null,null,{"$f":"IF(ok_pp=1,+G189,\" \")","v":" "},{"$f":"IF(OK_P=1,+H189,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.02 Gennemsnitligt beskatningsgrundlag pr. indbygger\"","v":"B.02 Gennemsnitligt beskatningsgrundlag pr. indbygger"},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$20/'Bilag 3'!$C$23,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$20/'Bilag 3'!$C$23,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.03 Forskel (pkt. B.02 - B.01)\"","v":"B.03 Forskel (pkt. B.02 - B.01)"},null,null,null,null,{"$f":"IF(ok_pp=1,+G199-G198,\" ---------- \")","v":" ---------- "},{"$f":"IF(OK_P=1,+H199-H198,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.04 Skattetryksfaktor \"","v":"B.04 Skattetryksfaktor "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.05 Udligningsprocent \"","v":"B.05 Udligningsprocent "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$D$27,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$D$27,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.06 Kommunens folketal 1.1.\"&aar&\" (jf. pkt. 1.05)\"","v":"B.06 Kommunens folketal 1.1.2025 (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.07 Beregnet udligningsbeløb (B.03 x B.04 x B.05 x B.06) \"","v":"B.07 Beregnet udligningsbeløb (B.03 x B.04 x B.05 x B.06) "},null,null,null,null,{"$f":"IF(ok_pp=1,+G200*G201*G202*G203,\" \")","v":" "},{"$f":"IF(OK_P=1,+H200*H201*H202*H203,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.08 12-Afrundet udligningsbeløb  \"","v":"B.08 12-Afrundet udligningsbeløb  "},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND(G204/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,3),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. B.03 Indgår uafrundet i udligningsberegningen, Pkt. B.08 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[null,{"$f":"\"Bilag C:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag C:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Tillæg for kommuner med lavt beskatningsgrundlag \"&aar","v":"Tillæg for kommuner med lavt beskatningsgrundlag 2025"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"C.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08\"","v":"C.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08"},null,null,null,null,{"$f":"IF(ok_pp=1,+G189,\" ---------- \")","v":" ---------- "},{"$f":"IF(OK_P=1,+H189,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.02 \"&TEXT(100*'Bilag 3'!D25,\"0,0\")&\" % af gennemsnitligt beskatningegrundlag pr. indbygger\"","v":"C.02 90,0 % af gennemsnitligt beskatningegrundlag pr. indbygger"},null,null,null,null,{"$f":"IF(OK_P=1,   'Bilag 3'!$D$25 *  'Bilag 3'!$C$20  /    'Bilag 3'!$C$23,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1, 'Bilag 3'!$D$25 *  'Bilag 3'!$C$20  /    'Bilag 3'!$C$23,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.03 positiv forskel (pkt. B.02 - B.01)\"","v":"C.03 positiv forskel (pkt. B.02 - B.01)"},null,null,null,null,{"$f":"IF(ok_pp=1,IF(+G215-G214>0,G215-G214,0),\" \")","v":" "},{"$f":"IF(OK_P=1,IF(+H215-H214>0,H215-H214,),\" ---------- \")","v":" ---------- "}]
[null,{"$f":"\"C.04 Skattetryksfaktor \"","v":"C.04 Skattetryksfaktor "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.05 Udligningsprocent \"","v":"C.05 Udligningsprocent "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$D$28,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$D$28,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.06 Kommunens folketal 1.1.\"&aar&\" (jf. pkt. 1.05)\"","v":"C.06 Kommunens folketal 1.1.2025 (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.07 Beregnet udligningsbeløb (C.03 x C.04 x C.05 x C.06) \"","v":"C.07 Beregnet udligningsbeløb (C.03 x C.04 x C.05 x C.06) "},null,null,null,null,{"$f":"IF(ok_pp=1,+G216*G217*G218*G219,\" \")","v":" "},{"$f":"IF(OK_P=1,+H216*H217*H218*H219,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.08 12-Afrundet udligningsbeløb    \"","v":"C.08 12-Afrundet udligningsbeløb    "},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND(G220/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,4),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. C.03 Indgår uafrundet i udligningsberegningen, Pkt. C.08 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[null,{"$f":"\"Bilag D:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag D:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Tillæg for kommuner med højt beskatningsgrundlag \"&aar","v":"Tillæg for kommuner med højt beskatningsgrundlag 2025"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"D.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08\"","v":"D.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08"},null,null,null,null,{"$f":"IF(ok_pp=1,+G189,\" ---------- \")","v":" ---------- "},{"$f":"IF(OK_P=1,+H189,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.02 \"&TEXT(100*'Bilag 3'!D26,\"0,0\")&\" % af gennemsnitligt beskatningegrundlag pr. indbygger\"","v":"D.02 125,0 % af gennemsnitligt beskatningegrundlag pr. indbygger"},null,null,null,null,{"$f":"IF(OK_P=1,   'Bilag 3'!$D$26 *  'Bilag 3'!$C$20  /    'Bilag 3'!$C$23,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1, 'Bilag 3'!$D$26 *  'Bilag 3'!$C$20  /    'Bilag 3'!$C$23,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.03 Negativ forskel (pkt. B.02 - B.01)\"","v":"D.03 Negativ forskel (pkt. B.02 - B.01)"},null,null,null,null,{"$f":"IF(ok_pp=1,IF(+G231-G230<0,G231-G230,0),\" ---------- \")","v":" ---------- "},{"$f":"IF(OK_P=1,IF(+H231-H230<0,H231-H230,),\" ---------- \")","v":" ---------- "}]
[null,{"$f":"\"D.04 Skattetryksfaktor \"","v":"D.04 Skattetryksfaktor "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.05 Udligningsprocent \"","v":"D.05 Udligningsprocent "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$D$29,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$D$29,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.06 Kommunens folketal 1.1.\"&aar&\" (jf. pkt. 1.05)\"","v":"D.06 Kommunens folketal 1.1.2025 (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.07 Beregnet udligningsbeløb (D.03 x D.04 x D.05 x D.06) \"","v":"D.07 Beregnet udligningsbeløb (D.03 x D.04 x D.05 x D.06) "},null,null,null,null,{"$f":"IF(ok_pp=1,+G232*G233*G234*G235,\" \")","v":" "},{"$f":"IF(OK_P=1,+H232*H233*H234*H235,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.08 12-Afrundet udligningsbeløb    \"","v":"D.08 12-Afrundet udligningsbeløb    "},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND(G236/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,5),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. D.03 Indgår uafrundet i udligningsberegningen, Pkt. D.08 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[null,{"$f":"\"Bilag E:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag E:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Udligning af udgiftsbehov \"&aar","v":"Udligning af udgiftsbehov 2025"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"E.01 Kommunens udgiftsbehov pr. indbygger (jf. statsgaranti)\"","v":"E.01 Kommunens udgiftsbehov pr. indbygger (jf. statsgaranti)"},null,null,null,null,{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,12) / VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,12) / VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"E.02 Gennemsnitligt udgifgtsbehov pr. indbygger\"","v":"E.02 Gennemsnitligt udgifgtsbehov pr. indbygger"},null,null,null,null,{"$f":"IF(OK_P=1,   'Bilag 3'!$C$32  /    'Bilag 3'!$C$33,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1, 'Bilag 3'!$C$32/    'Bilag 3'!$C$33,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"E.03 Forskel (pkt. B.01 - B.02)\"","v":"E.03 Forskel (pkt. B.01 - B.02)"},null,null,null,null,{"$f":"IF(ok_pp=1,G246-G247,\"    ---------- \")","v":"    ---------- "},{"$f":"IF(OK_P=1,H246-H247,\"     ---------- \")","v":"     ---------- "}]
[null,{"$f":"\"E.04 Udligningsprocent \"","v":"E.04 Udligningsprocent "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$D$35,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$D$35,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"E.05 Kommunens folketal 1.1.\"&aar&\" (jf. pkt. 1.05)\"","v":"E.05 Kommunens folketal 1.1.2025 (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"E.06 Beregnet udligningsbeløb (E.03 x E.04 x E.05) \"","v":"E.06 Beregnet udligningsbeløb (E.03 x E.04 x E.05) "},null,null,null,null,{"$f":"IF(ok_pp=1,+G248*G249*G250,\" \")","v":" "},{"$f":"IF(OK_P=1,+H248*H249*H250,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"E.07 12-Afrundet udligningsbeløb  \"","v":"E.07 12-Afrundet udligningsbeløb  "},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND(G251/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,9),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. E.03 Indgår uafrundet i udligningsberegningen, Pkt. E.07 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[null,{"$f":"\"Bilag F:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag F:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Tillæg for kommuner med højt udgiftsbehov \"&aar","v":"Tillæg for kommuner med højt udgiftsbehov 2025"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"F.01 Kommunens udgiftsbehov pr. indbygger (jf. statsgaranti)\"","v":"F.01 Kommunens udgiftsbehov pr. indbygger (jf. statsgaranti)"},null,null,null,null,{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,12) / VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,12) / VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"F.02 Gennemsnitligt udgifgtsbehov pr. indbygger\"","v":"F.02 Gennemsnitligt udgifgtsbehov pr. indbygger"},null,null,null,null,{"$f":"IF(OK_P=1,   'Bilag 3'!$C$32  /    'Bilag 3'!$C$33,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1, 'Bilag 3'!$C$32/    'Bilag 3'!$C$33,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"F.03 Positiv forskel (pkt. B.01 - B.02)\"","v":"F.03 Positiv forskel (pkt. B.01 - B.02)"},null,null,null,null,{"$f":"IF(ok_pp=1,IF(G261-G262>0,G261-G262,0),\"      ---------- \")","v":"      ---------- "},{"$f":"IF(OK_P=1,IF(H261-H262>0,H261-H262,0),\"           ---------- \")","v":"           ---------- "}]
[null,{"$f":"\"F.04 Udligningsprocent \"","v":"F.04 Udligningsprocent "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$D$36,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$D$36,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"F.05 Kommunens folketal 1.1.\"&aar&\" (jf. pkt. 1.05)\"","v":"F.05 Kommunens folketal 1.1.2025 (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"F.06 Beregnet udligningsbeløb (E.03 x E.04 x E.05) \"","v":"F.06 Beregnet udligningsbeløb (E.03 x E.04 x E.05) "},null,null,null,null,{"$f":"IF(ok_pp=1,+G263*G264*G265,\" \")","v":" "},{"$f":"IF(OK_P=1,+H263*H264*H265,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"F.07 12-Afrundet udligningsbeløb  \"","v":"F.07 12-Afrundet udligningsbeløb  "},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND(G266/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,10),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. F.03 Indgår uafrundet i udligningsberegningen, Pkt. F.07 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[null,{"$f":"\"Bilag G:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag G:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Finansieringsbidrag fordelt efter folketal (statstilskud, indvandrerbidrag mv.) \"&aar","v":"Finansieringsbidrag fordelt efter folketal (statstilskud, indvandrerbidrag mv.) 2025"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"G.01 Bloktilskud (ordinært) i \"&aar&\", der fordeles efter folketal \"","v":"G.01 Bloktilskud (ordinært) i 2025, der fordeles efter folketal "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$10,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$10,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.02 Bloktilskud (betinget vedr service ) i \"&aar&\", der fordeles efter folketal \"","v":"G.02 Bloktilskud (betinget vedr service ) i 2025, der fordeles efter folketal "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$11,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$11,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.03 Bloktilskud (betinget vedr anlæg) i \"&aar&\", der fordeles efter folketal \"","v":"G.03 Bloktilskud (betinget vedr anlæg) i 2025, der fordeles efter folketal "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$12,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$12,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.04 Bidragspulje til udligningsordn. indv. og efterkommere \"&aar","v":"G.04 Bidragspulje til udligningsordn. indv. og efterkommere 2025"},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$38,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$38,\"---------- \")","v":"---------- "}]
[null,{"$f":"+\"G.05 Bidragspulje til korrektion vedr. overudligning \"&aar","v":"G.05 Bidragspulje til korrektion vedr. overudligning 2025"},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$40,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$40,\"---------- \")","v":"---------- "}]
[null,{"$f":"+\"G.06 Finansiering af tillæg vedr. beskatningsgrundlag \"&aar","v":"G.06 Finansiering af tillæg vedr. beskatningsgrundlag 2025"},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$41,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$41,\"---------- \")","v":"---------- "}]
[null,{"$f":"+\"G.07 Finansiering af tillæg vedr. udgiftsbehov  \"&aar","v":"G.07 Finansiering af tillæg vedr. udgiftsbehov  2025"},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$42,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$42,\"---------- \")","v":"---------- "}]
[]
[null,{"$f":"\"G.08 Samlet folketal \"&aar&\" i hele landet \"","v":"G.08 Samlet folketal 2025 i hele landet "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$33,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$33,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.09 Kommunens folketal\"","v":"G.09 Kommunens folketal"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.10 Kommunens andel af samlet folketal (pkt. G.09/G.08)\"","v":"G.10 Kommunens andel af samlet folketal (pkt. G.09/G.08)"},null,null,null,null,{"$f":"IF(ok_pp=1,+G285/G284,\" \")","v":" "},{"$f":"IF(OK_P=1,+H285/H284,\"---------- \")","v":"---------- "}]
[]
[null,{"$f":"\"G.11 Kommunens andel af ordinært bloktilskud (E.01 x G.10)\"","v":"G.11 Kommunens andel af ordinært bloktilskud (E.01 x G.10)"},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND((G276*$G$286)/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,17),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.12 Kommunens andel af betinget bloktilskud (service) (G.02 x G.10)\"","v":"G.12 Kommunens andel af betinget bloktilskud (service) (G.02 x G.10)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,18),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.13 Kommunens andel af betinget bloktilskud (anlæg) (G.03 x G.10)\"","v":"G.13 Kommunens andel af betinget bloktilskud (anlæg) (G.03 x G.10)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,19),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.14 Kommunens bidrag vedr. indv. og efterkommere (G.04 x G.08)\"","v":"G.14 Kommunens bidrag vedr. indv. og efterkommere (G.04 x G.08)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,14),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.15 Kommunen korrektion vedr. overudligning (G.05 x G.10)\"","v":"G.15 Kommunen korrektion vedr. overudligning (G.05 x G.10)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,8),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.16 Kommunens finansieringsandel af tillæg vedr. beskatningsgrundlag (G.06 x G.10)\"","v":"G.16 Kommunens finansieringsandel af tillæg vedr. beskatningsgrundlag (G.06 x G.10)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,6),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.17 Kommunens finansieringsandel af tillæg vedr. udgiftsbehov (G.075 x G.10)\"","v":"G.17 Kommunens finansieringsandel af tillæg vedr. udgiftsbehov (G.075 x G.10)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,11),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. G.10 Indgår uafrundet i udligningsberegningen, Pkt. G.11-G.17 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Bilag 1 ","index":1,"n_rows":115,"n_cols":53,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Bilagstabel 1: Udligningsbeløb statsgaranti \"&aar","v":"Bilagstabel 1: Udligningsbeløb statsgaranti 2025"},null,null,null,null,null,"samle 1",null,null,null,null,null,null,"samle 2",null,null,null,"samle 3",null,null,null,null,null,null,null,"samle 4.1",null,null,null,null,null,null,null,null,null,null,null,null,"samle 4.2"]
[]
["knr","kommunenavn"," Udlig-"," Tillæg"," Tillæg"," Finan-"," Over-"," Korrek-"," Udlig-"," Tillæg"," Finan-"," Særlig"," Tilskud"," Bidrag"," Udlig-"," Udlig-"," Ordinært"," Betinget"," Betinget"," Finan-"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Bidrag"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud","Kompen-"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Moms-"," Moms-"," Tilskud",null," Indivi-"," Indivi-"," Midler-"," Midler-"," Midler-"," Midler-"," Per-"," Indivi-"," Indivi-"," Indivi-"]
[null,null," ning"," for kom-"," for kom-"," siering"," udlig-"," tion"," ning"," for"," siering"," kom-"," vedr."," vedr."," ning"," ning"," blok-"," blok-"," blok-"," sierings-"," til"," til"," til"," til"," til"," til"," til"," til"," til"," vedr."," til"," til"," til kom-","sations-"," til"," til"," til"," til"," kompen-"," kompen-"," til",null," duelle"," duelle"," tidigt"," tidigt"," tidigt"," tidigt"," manent"," duel"," duel"," duel"]
[null,null," af"," muner"," muner"," af"," ning"," vedr."," udgifts-"," kom-"," af"," pen-"," ind-"," ind-"," af"," af"," tilskud"," tilskud"," tilskud"," tilskud"," bedre"," generelt"," styrket"," værdig"," bekæm-"," udsatte"," udsatte"," udsatte"," grænse-"," høj"," Furesø"," vanske-"," muner","tilskud"," kom-"," kom-"," nedsæt-"," nedsæt-"," sation"," sation","færge-",null," tilskud"," tilskud"," tilskud"," tilskud"," tilskud"," tilskud"," tilskud"," mod-"," mod-"," mod-"]
[null,null," beskat-"," med"," med"," tillæg",null," over-"," behov"," muner"," tillæg"," sation"," vandrer"," vandrer"," sel-"," dæk-",null," vedr."," vedr.",null," kvalitet"," løft i"," kvalitet"," ældre-"," pelse"," ø-"," hoved-"," hoved-"," nære"," krimi-"," Kom-"," ligt"," med","vedr."," muner"," muner"," telse"," telse"," vedr."," vedr.","drift",null," vedr."," vedr."," vedr."," vedr."," vedr."," vedr."," vedr."," regning"," regning"," regning"]
[null,null," nings-"," lavt"," højt"," vedr.",null," udlig-",null," med"," vedr.",null," og"," og"," skabs-"," nings-",null," service-"," anlæg",null," i dag-"," ældre-"," ældre-"," pleje"," af"," og"," stads-"," stads-"," kom-"," nalitet"," mune"," stillede"," vanske-","netto-"," med"," på øer"," af"," af"," færge-"," færge-",null,null," skatte-"," skatte-"," skatte-"," skatte-"," skatte-"," skatte-"," skatte-"," sfa."," sfa."," sfa."]
[null,null," grundlag"," beskat-"," beskat-"," beskat-",null," ning",null," højt"," udgifts-",null," efter-"," efter-"," skat"," afgift",null," udgifter",null,null," tilbud"," plejen"," pleje",null," ensom-"," yder-"," kom-"," kom-"," muner"," i visse",null," kom-"," lige","tab sfa."," mindre"," uden"," takster"," takster"," takster"," takster",null,null," nedsæt-"," nedsæt-"," nedsæt-"," nedsæt-"," nedsæt-"," nedsæt-"," nedsæt-"," skatte-"," skatte-"," skatte-"]
[null,null,null," nings-"," nings-"," nings-",null,null,null," udgifts-"," behov",null," kom-"," kom-",null,null,null,null,null,null,null,null,null,null," hed på"," kom-"," muner"," muner",null," bolig-",null," muner"," økono-","ændring"," øer"," fast"," for"," for"," for"," for",null,null," telser"," telser"," telser"," telser"," telser"," telser"," telser"," stig-"," stig-"," stig-"]
[null,null,null," grundlag"," grundlag"," grundlag",null,null,null," behov",null,null," mere"," mere",null,null,null,null,null,null,null,null,null,null," ældre-"," muner",null,null,null," områder",null,null," miske","i dæk-",null," forbin-"," gods-"," passa-"," gods-"," passa-",null,"(tom 2025)","(ØA)","(ØA)","(Udl.ref)","(Udl.ref)","(Udl.ref)","(Udl.ref)","(Udl.ref)"," ninger"," ninger"," ninger","(tom 2025)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," området",null,null,null,null,null,null,null," vilkår","nings-",null," delse"," transport"," gerer mv."," transport"," gerer mv.",null,null,"2021-2022"," 2022-2023"," 2020-2021"," 2021-2022","2022-2023","2023-2024"," 2020-2021","2021-2022","2022-2023","2023-2024"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"afgiften"]
[null,null,3,{"$f":"+C13+1","v":4},{"$f":"+D13+1","v":5},6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,{"$f":"+AG13+1","v":34},{"$f":"+AH13+1","v":35},{"$f":"+AI13+1","v":36},{"$f":"+AJ13+1","v":37},{"$f":"+AK13+1","v":38},{"$f":"+AL13+1","v":39},{"$f":"+AM13+1","v":40},{"$f":"+AN13+1","v":41},{"$f":"+AO13+1","v":42},{"$f":"+AP13+1","v":43},{"$f":"+AQ13+1","v":44},{"$f":"+AR13+1","v":45},{"$f":"+AS13+1","v":46},{"$f":"+AT13+1","v":47},{"$f":"+AU13+1","v":48},{"$f":"+AV13+1","v":49},{"$f":"+AW13+1","v":50},{"$f":"+AX13+1","v":51},{"$f":"+AY13+1","v":52},{"$f":"+AZ13+1","v":53}]
[null,null,1,{"$f":"+C14+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51]
[]
[1,"Kommuner i alt",{"$f":"SUM(C18:C115)","v":0},340800,-1266864,926064,261720,-261720,0,247272,-247272,0,3474000,-3474000,0,0,79510704,3000000,999996,3500004,648204,863700,1157304,1212096,115596,1711596,689904,-412596,114096,102804,35604,936,363300,454008,135600,226500,44100,156204,9396,8604,2400,0,{"$f":"SUM(AQ18:AQ115)","v":3552},72468,111468,26052,33816,{"$f":"SUM(AV18:AV115)","v":72132},257544,-6372,-168000,-333492,0]
[]
[101,"København",-1491660,0,0,102828,0,-29064,-2666592,0,-27456,182604,526044,-385752,-560532,-19908,8828928,333120,111036,166560,76632,47220,63276,66264,6324,0,0,-57756,28524,28548,0,0,0,0,0,0,0,0,0,0,0,0,0,65808,0,0,0,72132,0,0,0,0]
[147,"Frederiksberg",-1217112,0,-11172,16200,1164,-4572,-903984,0,-4320,-24384,53616,-60768,56472,-1944,1390812,52476,17496,26232,11448,13092,17532,18360,1752,0,0,-12012,0,0,0,0,0,11172,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-74568,-134196]
[151,"Ballerup",-55212,0,0,8004,0,-2256,384180,8268,-2136,-11340,42984,-30012,-120948,-96,686892,25920,8640,27276,6204,7632,10224,10704,1020,0,30348,-4776,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[153,"Brøndby",317796,37380,0,6144,0,-1740,570564,12276,-1644,47592,57180,-23052,-36192,144,527652,19908,6636,36060,5064,4992,6696,7008,672,0,69936,-2988,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[155,"Dragør",-245388,0,-19920,2244,1128,-636,-83004,0,-600,-3336,4164,-8424,12060,192,192924,7284,2424,3636,1656,2664,3564,3744,360,0,0,-2196,0,0,0,0,0,336,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[157,"Gentofte",-3357744,0,-605220,11568,91596,-3264,-513552,0,-3084,-17568,45024,-43404,-86520,312,993276,37476,12492,18744,7764,11712,15684,16428,1572,0,0,-111168,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-6312,0,0]
[159,"Gladsaxe",-314496,0,0,10956,0,-3096,129216,2784,-2928,-16404,81804,-41112,-313248,732,940812,35496,11832,17748,8868,8568,11484,12024,1152,0,0,-7056,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[161,"Glostrup",-40668,0,0,3672,0,-1044,112260,2412,-984,-5304,23304,-13788,-18732,-984,315432,11904,3972,12528,2856,3204,4284,4488,432,0,13932,-2184,4560,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-19740,0]
[163,"Herlev",14580,0,0,4644,0,-1308,190680,4104,-1236,-6780,28692,-17436,6276,-1716,398928,15048,5016,15840,3348,4176,5592,5856,564,0,35244,-2688,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[165,"Albertslund",113016,0,0,4272,0,-1212,406308,8736,-1140,84192,32268,-16032,-1020,240,366972,13848,4620,25080,2964,3624,4848,5076,480,0,32424,-2316,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[167,"Hvidovre",15420,0,0,8328,0,-2352,263628,5664,-2220,33024,42108,-31248,16740,-144,715080,26976,8988,28392,6456,6708,8988,9420,900,0,63180,-4872,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7740,0,0,0,0,0]
[169,"Høje-Taastrup",323796,16368,0,9072,0,-2568,222876,4788,-2424,132984,81828,-34056,-37032,504,779436,29412,9804,30948,7668,6612,8856,9276,888,0,68868,-4464,0,5712,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[173,"Lyngby-Taarbæk",-1243536,0,-140640,9096,20124,-2568,-386412,0,-2424,-13068,43860,-34140,-67548,-2088,781248,29472,9828,14736,6168,8316,11136,11664,1116,0,0,-22608,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[175,"Rødovre",123228,0,0,6960,0,-1968,219696,4728,-1860,18264,48084,-26100,32208,264,597396,22536,7512,23724,5544,5700,7632,7992,756,0,52776,-3588,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[183,"Ishøj",159024,14040,0,3684,0,-1044,347328,7464,-984,114948,36672,-13800,15204,204,315936,11916,3972,21588,2820,2604,3492,3660,348,0,41868,-1776,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[185,"Tårnby",-62400,0,0,6816,0,-1920,119688,2580,-1824,840,24792,-25560,20376,600,585108,22080,7356,11040,5244,5808,7788,8160,780,0,51696,-4128,11412,0,0,0,0,1164,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-39924]
[187,"Vallensbæk",16080,0,0,2772,0,-780,-51672,0,-744,9024,26088,-10392,12,264,237780,8976,2988,4488,2496,2220,2976,3108,300,0,0,-1572,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[190,"Furesø",-597252,0,-28632,6612,1152,-1872,-135096,0,-1764,-9696,26820,-24816,22716,564,567912,21432,7140,10716,5436,6888,9228,9660,924,0,0,-5124,0,0,35604,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[201,"Allerød",-383256,0,-22308,4020,0,-1140,-221256,0,-1068,-6048,12288,-15072,-7440,204,344904,13008,4344,6504,3180,4116,5520,5784,552,0,0,-3120,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-26592,0]
[210,"Fredensborg",-300480,0,0,6528,0,-1848,-32880,0,-1740,-9600,28824,-24492,-23988,576,560568,21156,7056,10572,4812,6972,9336,9780,936,0,0,-4536,0,0,0,0,0,384,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[217,"Helsingør",-359988,0,0,9912,0,-2796,89520,1920,-2652,-14688,27972,-37176,37800,624,850956,32112,10704,16056,6528,11604,15540,16284,1548,0,0,-6516,11412,5712,0,0,0,1224,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-12,0,0]
[219,"Hillerød",-282024,0,0,8520,0,-2412,-291288,0,-2268,-12012,30852,-31944,-36792,180,731220,27588,9192,13800,6384,7536,10104,10584,1008,0,0,-5340,0,0,0,0,0,3852,0,0,0,0,0,0,0,0,0,0,0,0,20844,0,0,0,0,0]
[223,"Hørsholm",-782568,0,-121536,3816,34416,-1080,-127620,0,-1020,-5844,11832,-14340,10164,204,328152,12384,4128,6192,2412,5352,7164,7500,720,0,0,-29148,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[230,"Rudersdal",-1962288,0,-317436,8856,112140,-2496,-343956,0,-2364,-13236,31176,-33204,-3216,624,760008,28680,9564,14340,6648,10260,13740,14388,1368,0,0,-67608,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[240,"Egedal",-223464,0,0,7092,0,-2004,-377124,0,-1896,-10164,22764,-26628,26892,660,609312,22992,7668,11496,6216,6072,8148,8532,816,0,0,-4572,0,0,0,0,0,5892,0,0,0,0,0,0,0,0,384,996,0,0,0,0,0,0,0,0]
[250,"Frederikssund",-81900,0,0,7212,0,-2040,-86508,0,-1920,11844,18948,-27036,32328,72,618780,23352,7788,11676,4428,8256,11064,11580,1104,0,54672,-4296,0,0,0,0,0,5988,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[253,"Greve",-181152,0,0,8100,0,-2292,-54732,0,-2160,-396,36000,-30396,29400,732,695640,26244,8748,13128,6216,7764,10392,10884,1032,0,0,-5160,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[259,"Køge",-11136,0,0,9780,0,-2760,40692,876,-2616,98232,34308,-36672,31344,468,839304,31668,10560,33336,7284,9012,12072,12636,1200,0,74160,-5520,0,5712,0,0,0,8124,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-12660,0]
[260,"Halsnæs",19608,0,0,4884,0,-1380,37404,804,-1308,85560,12732,-18312,24060,372,419196,15816,5268,16644,2724,6192,8304,8700,828,0,55560,-2820,0,0,0,0,0,408,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[265,"Roskilde",-560580,0,0,14160,0,-3996,-466152,0,-3780,-20604,43668,-53100,45924,-1044,1215300,45852,15288,22932,9540,13188,17676,18516,1764,0,0,-9132,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[269,"Solrød",-163932,0,0,3840,0,-1080,-168852,0,-1020,-5460,11148,-14388,21456,360,329232,12420,4140,6216,3252,3432,4596,4812,456,0,0,-2448,0,0,0,0,0,3180,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[270,"Gribskov",-245904,0,0,6504,0,-1836,-86964,0,-1740,-9648,14364,-24396,35616,108,558468,21072,7020,10536,3756,8376,11220,11760,1116,0,0,-4332,0,0,0,0,0,5400,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[306,"Odsherred",-1596,0,0,5028,0,-1416,243564,5244,-1344,-7764,10560,-18876,28380,384,432012,16296,5436,17160,2244,7440,9960,10440,996,0,0,0,0,0,0,0,0,4176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,16056,0,0,0]
[316,"Holbæk",158076,0,0,11544,0,-3264,134304,2892,-3084,-16776,36468,-43284,55056,1080,990720,37380,12456,39348,7728,11436,15336,16056,1536,0,0,0,0,0,0,0,0,9588,10932,0,1116,10416,336,1236,0,0,2064,0,0,0,0,0,0,0,0,0]
[320,"Faxe",152328,0,0,5868,0,-1656,20568,444,-1572,-8604,14688,-22008,21108,552,503796,19008,6336,34428,3576,6144,8220,8616,816,18612,0,0,0,0,0,0,15252,4872,0,0,0,0,0,0,0,0,0,0,9144,0,0,0,0,0,0,0]
[326,"Kalundborg",103632,0,0,7464,0,-2112,346932,7464,-1992,-11388,21936,-27984,-61224,660,640512,24168,8052,25440,4164,8580,11508,12048,1152,47328,0,0,0,0,0,0,0,6192,13356,0,2052,1548,444,0,0,0,0,0,24708,13572,0,0,0,0,0,0]
[329,"Ringsted",115668,0,0,5664,0,-1596,29160,624,-1512,-8172,20652,-21228,24900,360,485844,18336,6108,33204,3936,4836,6480,6792,648,0,0,0,0,0,0,0,0,4704,0,0,0,0,0,0,0,0,0,0,8052,0,0,0,21480,0,0,0]
[330,"Slagelse",346116,0,0,12396,0,-3504,527292,11340,-3312,-18588,45168,-46488,57108,24,1063968,40140,13380,72708,7980,12780,17124,17928,1704,0,0,0,0,11424,0,0,0,10296,13764,0,1356,2808,0,0,0,0,0,0,0,0,0,0,0,0,-21744,-31464]
[336,"Stevns",11256,0,0,3684,0,-1044,-18288,0,-984,12936,8448,-13800,21000,336,315960,11916,3972,5964,2304,4296,5760,6036,576,0,27912,-2016,0,0,0,0,0,3060,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[340,"Sorø",91416,0,0,4728,0,-1332,39948,864,-1260,-6996,11004,-17736,22356,384,405924,15312,5100,16116,3252,4848,6504,6816,648,15000,0,0,0,0,0,0,0,3924,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5052,0,0,0]
[350,"Lejre",-66204,0,0,4572,0,-1296,-153012,0,-1224,-6516,10464,-17136,16728,384,392316,14808,4932,7404,3516,4560,6108,6396,612,0,17328,-2760,0,0,0,0,0,3792,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[360,"Lolland",235620,15900,0,6084,0,-1716,770496,16572,-1620,22776,18588,-22836,22320,480,522732,19728,6576,35724,2892,8580,11496,12036,1152,57948,0,0,0,0,0,0,15828,5052,23484,0,2604,4632,564,0,0,0,0,0,0,0,0,0,43272,0,0,0]
[370,"Næstved",285000,0,0,13152,0,-3720,198204,4260,-3516,-19464,38172,-49320,66384,732,1128864,42588,14196,77136,8292,13560,18168,19032,1812,0,0,0,0,0,0,0,0,10920,0,0,0,0,0,0,0,0,588,0,0,0,0,0,0,0,0,0]
[376,"Guldborgsund",259296,0,0,9216,0,-2604,572532,12312,-2460,-14256,24036,-34584,48900,276,791580,29868,9960,54096,5100,11748,15744,16488,1572,87744,0,0,0,0,0,0,23964,7656,0,0,0,0,0,0,0,0,0,0,33564,0,0,0,0,0,0,0]
[390,"Vordingborg",155544,0,0,7080,0,-2004,263016,5652,-1884,-10740,18744,-26544,38856,336,607656,22932,7644,41520,3492,9120,12216,12792,1224,67356,0,0,0,0,0,0,18396,5880,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-12696,-21384]
[400,"Bornholm",256584,21624,0,6072,0,-1716,118776,2556,-1620,21756,12960,-22776,34332,300,521256,19668,6552,35616,3444,8496,11376,11916,1140,77040,0,0,0,0,0,0,15780,5040,0,57528,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[410,"Middelfart",18972,0,0,6252,0,-1764,-98904,0,-1668,-9048,14220,-23460,19392,228,536796,20256,6756,10128,4260,6912,9264,9708,924,0,0,0,0,0,0,0,0,5196,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[420,"Assens",209196,7380,0,6276,0,-1776,125148,2688,-1680,-9648,12540,-23556,13848,588,539160,20340,6780,36840,3900,6996,9384,9828,936,39840,0,0,0,0,0,0,16320,5220,2712,0,696,552,120,48,0,0,0,0,0,0,0,0,0,0,0,0]
[430,"Faaborg-Midtfyn",318936,22536,0,8112,0,-2292,70020,1512,-2160,-12156,17820,-30432,37536,636,696396,26280,8760,47592,5268,9420,12624,13224,1260,77196,0,0,0,0,0,0,21084,6732,8220,0,1008,2352,156,192,0,0,0,0,0,0,0,0,0,0,0,0]
[440,"Kerteminde",46464,0,0,3696,0,-1044,33168,708,-984,-5568,10752,-13872,12996,324,317388,11976,3996,21684,2352,4572,6132,6420,612,23448,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,516,0,2688,3072,0,0,3600,0,0,0]
[450,"Nyborg",138948,0,0,4980,0,-1404,141552,3048,-1332,-7524,14520,-18708,25680,468,428040,16152,5388,29244,2964,5880,7872,8244,780,47448,0,0,0,0,0,0,0,4140,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4884,0,0,0]
[461,"Odense",1142340,54180,0,32496,0,-9180,151536,3264,-8676,-48072,135648,-121884,79836,468,2789616,105252,35088,190632,22572,26496,35508,37188,3552,0,0,0,0,17136,0,0,0,26988,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[479,"Svendborg",314064,12108,0,9288,0,-2628,98700,2124,-2484,-13740,22872,-34860,44916,552,797952,30108,10032,54528,6168,10560,14148,14820,1416,88452,0,0,0,0,0,0,0,7716,8520,0,264,552,0,0,0,0,0,0,0,0,0,0,42732,0,0,0]
[480,"Nordfyn",136176,1032,0,4572,0,-1296,75336,1620,-1224,-6972,11844,-17172,18252,420,393060,14832,4944,26856,2820,5112,6852,7176,684,43572,0,0,0,0,0,0,11892,3804,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[482,"Langeland",70020,4104,0,1884,0,-528,128604,2760,-504,9708,4452,-7092,9636,180,162252,6120,2040,11088,720,3204,4284,4488,432,29976,0,0,0,0,0,0,4908,1572,4884,0,612,468,168,72,0,0,0,0,0,0,0,0,27396,0,0,0]
[492,"Ærø",50688,6408,0,924,0,-264,28764,624,-252,10032,1644,-3456,5844,72,79212,2988,996,5412,360,1608,2160,2256,216,14628,0,0,0,0,0,0,2400,768,1296,59076,10236,33936,2604,420,0,0,0,0,0,0,0,0,0,0,0,0]
[510,"Haderslev",292896,12156,0,8556,0,-2412,310488,6672,-2280,-13056,30600,-32100,34092,540,734592,27720,9240,50196,5280,9648,12936,13548,1296,81432,0,0,0,0,0,0,0,7104,4560,0,348,1680,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[530,"Billund",74100,0,0,4200,0,-1188,37800,816,-1128,-6252,19860,-15768,-123708,276,360936,13620,4536,24660,2880,4236,5676,5952,564,0,0,0,0,0,0,0,0,3492,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[540,"Sønderborg",283476,0,0,11460,0,-3240,408720,8784,-3060,-9408,47676,-43008,32964,768,984432,37140,12384,67272,6708,13740,18420,19284,1836,72744,0,0,19392,0,0,0,0,9516,0,0,0,0,0,0,1121,0,0,0,0,0,0,0,0,0,0,0]
[550,"Tønder",183480,5388,0,5652,0,-1596,272712,5868,-1512,-7368,18192,-21192,29568,456,484944,18300,6096,33132,3360,7020,9396,9852,936,53760,0,0,10272,0,0,0,14676,4692,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[561,"Esbjerg",309996,0,0,17868,0,-5052,309288,6648,-4776,-27084,57936,-67032,59928,876,1534140,57888,19296,104832,12228,17952,24060,25200,2400,0,0,0,0,5712,0,0,0,14844,480,0,108,0,36,0,0,0,0,0,0,0,0,0,0,0,0,0]
[563,"Fanø",-29436,0,0,516,0,-144,-14172,0,-132,-684,732,-1932,2988,48,44148,1668,552,828,240,864,1152,1200,120,0,0,0,0,0,0,0,0,432,0,0,5988,39360,1728,3108,0,0,0,0,0,0,0,0,0,0,0,0]
[573,"Varde",111420,0,0,7692,0,-2172,102972,2220,-2052,-11724,19728,-28848,31272,336,660372,24912,8304,26220,5196,8556,11460,12000,1140,48804,0,0,0,0,0,0,0,6384,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[575,"Vejen",183756,0,0,6612,0,-1872,73812,1584,-1764,-10032,21732,-24828,15816,588,568140,21432,7140,38820,4572,6768,9072,9504,900,0,0,0,0,0,0,0,17196,5496,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[580,"Aabenraa",309636,12756,0,9060,0,-2556,275868,5928,-2424,-13812,27600,-33984,-1668,384,777672,29340,9780,53136,5580,10380,13908,14568,1392,57468,0,0,28524,0,0,936,23544,7524,2328,0,204,264,12,0,0,0,0,0,0,0,0,0,0,0,0,0]
[607,"Fredericia",113412,0,0,8148,0,-2304,310464,6672,-2172,-12084,31116,-30576,-20796,564,699852,26400,8808,27792,5304,8088,10848,11364,1080,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5664,0,0,0,0,0,0,0,0]
[615,"Horsens",457188,3948,0,15300,0,-4320,-46524,0,-4092,18612,56916,-57408,43020,972,1314024,49584,16524,89796,12252,12888,17280,18096,1728,0,0,0,0,0,0,0,0,12708,10860,0,660,720,96,24,0,0,0,0,0,0,0,0,0,0,0,-22188]
[621,"Kolding",187284,0,0,14736,0,-4164,6672,144,-3936,-21840,60732,-55284,20232,396,1265388,47748,15912,50256,10668,13320,17856,18696,1788,0,0,0,0,5712,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[630,"Vejle",89208,0,0,19008,0,-5376,-61152,0,-5076,-27084,78396,-71316,64848,1176,1632240,61584,20532,64824,14832,16716,22404,23460,2232,0,0,0,0,0,0,0,0,15792,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[657,"Herning",298872,0,0,13920,0,-3936,-133632,0,-3720,-20904,49440,-52224,26448,-2244,1195260,45096,15036,81672,9984,13332,17868,18720,1788,0,0,0,0,0,0,0,0,11556,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-36960]
[661,"Holstebro",288648,6552,0,9132,0,-2580,-88944,0,-2436,-13728,29508,-34272,35388,384,784380,29592,9864,53604,6588,9132,12240,12828,1224,0,0,0,0,0,0,0,0,7584,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[665,"Lemvig",7884,0,0,2940,0,-828,47004,1008,-780,-4644,8664,-11016,8520,240,251988,9504,3168,10008,1656,3828,5136,5376,516,18624,0,0,0,0,0,0,0,2436,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[671,"Struer",91548,12,0,3168,0,-900,90264,1944,-840,-576,10596,-11880,16668,300,271812,10260,3420,18576,1704,4116,5508,5772,552,30132,0,0,0,0,0,0,8232,2628,4284,0,288,2184,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[706,"Syddjurs",115212,0,0,6852,0,-1932,-115344,0,-1824,-10056,13464,-25704,33648,612,588360,22200,7404,23364,4956,8172,10956,11472,1092,43476,0,0,0,0,0,0,0,5688,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[707,"Norddjurs",178188,3672,0,5688,0,-1608,220272,4740,-1524,-8820,14640,-21336,25392,336,488412,18432,6144,33372,3312,6948,9312,9756,936,54144,0,0,0,0,0,0,14784,4728,8832,0,2352,3612,312,0,0,0,0,0,0,9408,5232,0,22548,0,0,0]
[710,"Favrskov",73596,0,0,7668,0,-2172,-293244,0,-2052,-11352,19476,-28752,31032,576,658092,24828,8280,12420,6516,6720,9000,9432,900,0,0,0,0,0,0,0,0,6360,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[727,"Odder",35940,0,0,3720,0,-1056,-50412,0,-996,-5340,9084,-13980,20724,348,319920,12072,4020,6036,2784,4224,5652,5928,564,0,0,0,0,0,0,0,0,3096,3564,0,720,1776,96,0,0,0,0,0,0,0,0,0,0,0,0,0]
[730,"Randers",531396,21696,0,15564,0,-4404,339432,7296,-4152,-22992,42780,-58404,60768,828,1336740,50436,16812,91344,11088,15012,20112,21072,2004,0,0,0,0,0,0,0,0,10728,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[740,"Silkeborg",199932,0,0,15816,0,-4476,-411912,0,-4224,-21924,41544,-59340,11736,1176,1358112,51240,17076,25620,13968,14172,18984,19884,1896,0,0,0,0,0,0,0,0,13140,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[741,"Samsø",6996,0,0,576,0,-168,9900,216,-156,-864,1188,-2160,3192,48,49308,1860,624,1956,288,948,1272,1332,132,5460,0,0,0,0,0,0,0,480,0,58836,8640,28668,1752,2052,0,0,0,0,456,0,0,0,0,0,0,0]
[746,"Skanderborg",-83724,0,0,10164,0,-2868,-452208,0,-2712,-14664,23856,-38136,30336,900,872916,32940,10980,16464,9696,8592,11520,12060,1152,0,0,0,0,0,0,0,0,8448,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-48,0,0]
[751,"Århus",423468,0,0,57348,0,-16212,-1644780,0,-15312,-81684,241212,-215136,-569628,-8220,4923924,185784,61932,92892,40524,38916,52152,54624,5208,0,0,0,0,17136,0,0,0,7008,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[756,"Ikast-Brande",242844,13524,0,6648,0,-1884,-15660,0,-1776,-9684,28884,-24936,-24420,588,570696,21528,7176,39000,4788,6324,8472,8880,852,0,0,0,0,0,0,0,0,5520,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[760,"Ringkøbing-Skjern",187488,0,0,8664,0,-2448,15312,324,-2316,-13308,28584,-32520,24000,600,744372,28080,9360,50868,5736,9720,13020,13632,1296,27504,0,0,0,0,0,0,0,7200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[766,"Hedensted",130608,0,0,7416,0,-2100,-180108,0,-1980,-10944,17292,-27804,3468,540,636408,24012,8004,25272,5280,7188,9624,10080,960,0,0,0,0,0,0,0,0,6156,3168,0,168,804,0,84,0,0,0,0,0,0,0,0,0,0,0,0]
[773,"Morsø",112068,6492,0,3036,0,-852,131268,2820,-816,23148,7704,-11388,7716,264,260640,9828,3276,17808,1752,3900,5220,5460,516,28896,0,0,0,0,0,0,7884,2520,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[779,"Skive",192432,0,0,6876,0,-1944,209340,4500,-1836,18384,18408,-25812,22560,456,590880,22296,7428,40380,3960,8256,11064,11580,1104,65496,0,0,0,0,0,0,17880,5712,7872,0,1056,4308,216,372,417,0,0,0,0,0,0,0,0,0,0,0]
[787,"Thisted",218736,7188,0,6636,0,-1872,130080,2796,-1776,-10188,16932,-24888,28620,420,569664,21492,7164,38928,4356,7668,10284,10764,1032,42096,0,0,0,0,0,0,17244,5508,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[791,"Viborg",344472,0,0,15084,0,-4260,-28608,0,-4032,-22824,46608,-56568,64164,-540,1294632,48852,16284,88464,9996,15108,20244,21204,2016,0,0,0,0,0,0,0,0,12528,0,0,0,0,0,0,0,0,0,0,23244,0,0,0,0,0,0,0]
[810,"Brønderslev",258432,25212,0,5676,0,-1608,63132,1356,-1512,-8532,16140,-21276,26436,360,486840,18372,6120,33264,4296,6036,8088,8472,804,53964,0,0,0,0,0,0,0,4704,0,0,0,0,0,0,0,0,0,0,0,0,0,0,31668,0,0,0]
[813,"Frederikshavn",236304,0,0,8988,0,-2544,316608,6804,-2400,24468,22620,-33696,-9888,432,771276,29100,9696,52704,4968,11820,15840,16596,1584,85488,0,0,0,0,0,0,23340,7464,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[820,"Vesthimmerland",164688,1164,0,5544,0,-1572,221460,4764,-1476,-8664,17400,-20808,20820,516,476208,17964,5988,32544,3252,6576,8808,9216,876,52788,0,0,0,0,0,0,14412,4608,0,0,0,0,0,0,862,0,0,0,0,0,0,0,38304,0,0,0]
[825,"Læsø",8184,96,0,276,0,-72,14628,312,-72,204,168,-1020,1560,24,23244,876,288,924,120,528,708,732,72,2580,0,0,0,0,0,0,708,228,0,51060,3444,15360,708,996,0,0,0,0,0,0,0,0,552,0,0,0]
[840,"Rebild",66096,0,0,4812,0,-1356,-134196,0,-1284,-7056,10680,-18036,17880,444,412680,15576,5196,28200,4248,4548,6084,6372,612,0,0,0,0,0,0,0,0,3996,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-13116]
[846,"Mariagerfjord",189960,888,0,6456,0,-1824,77436,1668,-1728,-9840,18252,-24216,11268,444,554316,20916,6972,37884,4164,7296,9780,10248,972,20484,0,0,0,0,0,0,16776,5364,0,0,0,0,0,0,0,0,0,0,9612,0,0,0,0,0,0,0]
[849,"Jammerbugt",186684,4260,0,5904,0,-1668,41172,888,-1572,-9000,12024,-22152,31680,516,507060,19128,6372,34644,3840,6828,9156,9588,912,37476,0,0,0,0,0,0,15348,4908,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[851,"Aalborg",946404,0,0,34764,0,-9828,-559440,0,-9276,-50688,109464,-130392,912,456,2984388,112608,37536,203940,23952,28980,38832,40668,3876,0,0,0,0,0,0,0,0,3180,2484,0,180,204,48,0,0,0,0,0,0,0,0,0,0,0,0,-34260]
[860,"Hjørring",293280,2736,0,9792,0,-2772,210420,4524,-2616,15144,25764,-36732,22464,312,840720,31716,10572,57456,6012,11580,15516,16248,1548,93192,0,0,0,0,0,0,25452,8136,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Bilag 2 ","index":2,"n_rows":115,"n_cols":14,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Bilagstabel 2: Grunddata til statsgaranti \"&aar","v":"Bilagstabel 2: Grunddata til statsgaranti 2025"},null,null,null," ",null,"lukkes sammen"]
[]
["knr","kommunenavn"," Udskriv-"," Indkomst-"," Udskriv-"," Grund-"," Grund-"," Grund-","Beregnings-","Beregnings-"," Beskat-"," Udgifts-"," Samlet"," Udgifts-"]
[null,null," nings-"," skat"," nings-"," skylds-"," skylds-"," skylds-","tekniske","tekniske"," nings-"," behov"," antal"," behov"]
[null,null," procent"," vedr."," grundlag"," promille,"," promille,"," provenu"," grund-"," grund-"," grundlag",null," indbyg-"," pr."]
[null,null,null," selv-"," vedr."," øvrige"," produk-",null," værdier,"," værdier,",null,null," gere"," indbygger"]
[null,null,null," angivne"," selv-"," ejen-"," tions-",null," øvrige"," produk-",null,null," (IM-"]
[null,null,null," indkomster"," angivne"," domme"," jord",null," ejen-"," tions-",null,null," skøn)"]
[null,null,null,null," indkomster",null,null,null," domme"," jord"]
[null,null,null,null," ","Anvendes ","Anvendes ","Anvendes "," "]
[null,null,null,null," ","ikke","ikke","ikke"," "]
[null,null,null,null," ","i 2024","i 2024","i 2024"," "]
[]
[null,null,1,{"$f":"+C14+1","v":2},3,4,5,6,7,8,9,10,11,12]
[]
[1,"Kommuner i alt ",{"$f":"100*D16/E16","v":25.074493720262971},{"$f":"SUM(D18:D115)","v":326113875},{"$f":"SUM(E18:E115)","v":1300580098},"---","---",{"$f":"SUM(H18:H115)","v":0},1183365740.9999995,122378946.99999999,1423378975,467172399.9999994,5984354,{"$f":"+L16/M16*1000","v":78065.635823014381}]
[]
[101,"København",23.599999999999898,36042372,152721915,0,0,0,131855301,0,165984908,49007856.4458386,664507,73750.700061607597]
[147,"Frederiksberg",24.57,7169455,29179711,0,0,0,21773929,0,31369896,7199800.9812072096,104679,68779.802837314099]
[151,"Ballerup",25.5,2797443,10970365,0,0,0,16099701,13460,12590208,4449005.9740872802,51699,86055.938685221903]
[153,"Brøndby",24.3,1671045,6876728,0,0,0,8741562,2606,7756100,3713804.7673148499,39714,93513.742441326802]
[155,"Dragør",24.8,1024608,4131484,0,0,0,6226905,18531,4758403,1044265.15055692,14520,71919.0875039206]
[157,"Gentofte",24.34,7623462,31320715,0,0,0,42902983,0,35636218,5283906.4815853098,74759,70679.202257725599]
[159,"Gladsaxe",23.599999999999898,3854241,16331530,0,0,0,21702216,121,18514505,5666773.9853608999,70810,80027.877211706]
[161,"Glostrup",24.6,1283337,5216817,0,0,0,6424385,1288,5863069,1974070.3970601,23741,83150.263133823697]
[163,"Herlev",23.6999999999999,1486061,6270300,0,0,0,7888036,4774,7063885,2548957.3233652799,30025,84894.498696595794]
[165,"Albertslund",25.6,1349747,5272449,0,0,0,6913263,19776,5968445,2593060.93785844,27620,93883.451768951694]
[167,"Hvidovre",25.4,2868120,11291811,0,0,0,14188756,2358,12719095,4484957.31930824,53820,83332.540306730603]
[169,"Høje-Taastrup",24.6,2680704,10897171,0,0,0,13170806,307084.99999999901,12231442,4819296.4095740002,58664,82150.832019194]
[173,"Lyngby-Taarbæk",24.3799999999999,4359805,17882711,0,0,0,26993928,4184,20598091,4174761.5613592998,58800,70999.346281620907]
[175,"Rødovre",25.6999999999999,2307149,8977233,0,0,0,10557565,0,10039192,3746298.93665251,44963,83319.594703478695]
[183,"Ishøj",25,1091087,4364348,0,0,0,4414417,59031,4810200,2229793.13204011,23779,93771.526642840807]
[185,"Tårnby",24.1,2287465,9491556,0,0,0,13067024.999999899,10379,10806255,3566550.9576408402,44038,80988.032100477794]
[187,"Vallensbæk",25.6,947016,3699281,0,0,0,4690292,688,4171087,1341503.47223722,17896,74961.079137082401]
[190,"Furesø",24.88,2907489,11686049,0,0,0,16442159,85907,13342569,3191576.3719739001,42744,74667.236851345195]
[201,"Allerød",25.3,1818601,7188146,0,0,0,10143999,123675,8212312,1788601.92875899,25959,68901.0335051039]
[210,"Fredensborg",25.3,2590806,10240340,0,0,0,13764058,263585,11632946,3258315.8846157799,42191,77227.747259268101]
[217,"Helsingør",25.52,3789834,14850447,0,0,0,22749184,295330,17147821,5096127.7326300601,64047,79568.562659141899]
[219,"Hillerød",25.6,3296692,12877703,0,0,0,16867737,498491,14589731,3983122.8645755001,55035,72374.359309085194]
[223,"Hørsholm",23.6999999999999,2037596,8597451,0,0,0,14287293,37938,10035742,1790838.03290361,24698,72509.435294502196]
[230,"Rudersdal",23.36,4789896,20504692,0,0,0,35122429,76308,24039918,4095666.2335954998,57202,71600.053033032105]
[240,"Egedal",25.6999999999999,2760692,10741992,0,0,0,13357624,340726,12096090,3174580.0010716701,45860,69223.288292012105]
[250,"Frederikssund",25.8,2670729,10351663,0,0,0,11308055,764686,11512651,3542655.3960476601,46572,76068.354291154799]
[253,"Greve",24.52,2886842,11773418,0,0,0,16298222,115404,13416368,4028426.6010470702,52357,76941.509273775606]
[259,"Køge",25.26,3439221,13615285,0,0,0,14393001,686765,15084181,4975164.3904595701,63170,78758.340833616807]
[260,"Halsnæs",25.6999999999999,1694448,6593183,0,0,0,7939583,271689,7400169,2503261.5462592999,31551,79340.165010912504]
[265,"Roskilde",25.2,5581187,22147567,0,0,0,25555441,606006,24736779,6639353.1121653896,91469,72585.828118437799]
[269,"Solrød",24.99,1473142,5894926,0,0,0,8621752,111890,6765610.9999999898,1752910.5717446101,24780,70738.925413422898]
[270,"Gribskov",25.4,2385262,9390795,0,0,0,18807551,732512,11305148,3187819.7457506699,42033,75840.880873377406]
[306,"Odsherred",26.3,1750961,6657646,0,0,0,10493450,942796,7742177,2800196.8338568099,32515,86120.154816448397]
[316,"Holbæk",25.3,3957251,15641308,0,0,0,11918933.999999899,1778669,16894955,5965448.49015834,74566,80002.259611060595]
[320,"Faxe",25.8,1971647,7642043,0,0,0,5200748,1417293,8208801,2982209.5155137698,37918,78648.913853942096]
[326,"Kalundborg",24.2,2457289,10154087,0,0,0,6984868,1901096,10915197,4136430.7441292601,48208,85803.823932319501]
[329,"Ringsted",26.1,1944968,7451985,0,0,0,5980415,937398,8082395,2885981.2632653201,36567,78923.107262431193]
[330,"Slagelse",26.1,4169700,15975862,0,0,0,11616114,2014215,17206300,6818393.07829013,80079,85145.831969556704]
[336,"Stevns",26,1329602,5113854,0,0,0,4480469,1036353,5596434,1836811.1559216599,23781,77238.6003919793]
[340,"Sorø",26.3,1659397,6309494,0,0,0,4388065,968345,6780686,2428021.3648244101,30552,79471.765017819198]
[350,"Lejre",25.31,1694105,6693422,0,0,0,6524277,832330,7375304,2140593.3954759599,29528,72493.680421158206]
[360,"Lolland",26.3,2026590,7705665,0,0,0,2735745,4028634,8104857,3899826.0546183102,39343,99123.759108820203]
[370,"Næstved",25,4323468,17293872,0,0,0,13212008,2286234,18693210,6845886.13914451,84964,80573.962373999806]
[376,"Guldborgsund",25.8,3093499,11990306,0,0,0,6810229,3784249,12791817,5266622.2379271602,59578,88398.775352095705]
[390,"Vordingborg",26.3,2461341,9358711,0,0,0,6213602,2185376,10050992,3853145.6505033202,45735,84249.385601909395]
[400,"Bornholms",26.2,1955352,7463176,0,0,0,4715158,958819,7966976,3190386.0681264,39232,81321.015194902298]
[410,"Middelfart",25.8,2294636,8893938,0,0,0,5805145,1002945,9508736,3047659.0646874201,40402,75433.371236261199]
[420,"Assens",26.1,2104349,8062640,0,0,0,4210863,1732913,8539543,3302471.24381688,40580,81381.745781588994]
[430,"Faaborg-Midtfyn",26.1,2633845,10091360,0,0,0,6081240,2197701,10770707,4167021.8469837699,52414,79502.076677677105]
[440,"Kerteminde",26.1,1313384,5032123,0,0,0,3779616,726423,5434666,1900494.0183132901,23888,79558.523874467995]
[450,"Nyborg",26.3,1697891,6455859,0,0,0,4328709,1053479,6923701,2667173.30570446,32216,82790.331068551706]
[461,"Odense",25.5,10340314,40550251,0,0,0,32745230,669217,43864611,16553608.6967753,209960,78841.725551416006]
[479,"Svendborg",26.3,3048326,11590593,0,0,0,9751877,1406210,12614796,4794599.8664766699,60058,79832.826042769797]
[480,"Nordfyn",26,1527953,5876742,0,0,0,3828112,1645277,6312447,2390501.5696625202,29584,80803.865929641703]
[482,"Langeland",26.3,609617.99999999895,2317939,0,0,0,1795691,1096473,2532315,1091615.4069688399,12212,89388.749342355499]
[492,"Ærø",26.1,282463,1082234,0,0,0,579084,261417,1148530,496356.19289252203,5962,83253.303068185502]
[510,"Haderslev",26.3,2877127,10939646,0,0,0,5541642,3118156,11593049,4650026.2096016798,55289,84104.002778159906]
[530,"Billund",24,1369581,5706588,0,0,0,3236520,1144914,6067384,2161380.2652158001,27166,79561.962203335002]
[540,"Sønderborg",25.6999999999999,3897090,15163774,0,0,0,8829261,2071295,16115646,6223597.1003256598,74093,83997.099595449807]
[550,"Tønder",25.3,1841867,7280106.9999999898,0,0,0,3196556,3378714,7705645,3142551.8493317598,36499,86099.669835660301]
[561,"Esbjerg",25.8,6222704,24119008,0,0,0,16249150,2013784,25815458,9346570.0208646692,115467,80945.811538055699]
[563,"Fanø",25.77,194092,753169.99999999895,0,0,0,1919608,21018,946906,244175.03784243,3323,73480.300283608405]
[573,"Varde",25.099999999999898,2571562,10245267,0,0,0,8828310,3121631,11229375,3990816.40060336,49703,80293.270036081594]
[575,"Vejen",25.33,2217389,8754003,0,0,0,3565293,2630995,9193615,3417534.5286812098,42761,79921.7634919954]
[580,"Aabenraa",25.6,2956766,11549867,0,0,0,6385887,2694310,12275144,4865889.3390528401,58531,83133.541867605905]
[607,"Fredericia",25.5,2812531,11029533,0,0,0,8783672,402706,11925456.999999899,4445867.7258425998,52674,84403.457604180599]
[615,"Horsens",25.69,5023948,19556045,0,0,0,14724573,1790562,21092270,7670669.6528192302,98900,77559.854932449205]
[621,"Kolding",25.5,5100943.9999999898,20003702,0,0,0,15702213,2389054,21656688,7442064.2488548504,95239,78140.932274119303]
[630,"Vejle",23.4,6222075,26590064,0,0,0,20518535,2973982,28745517,9524602.9526144899,122850,77530.345564627496]
[657,"Herning",25.4,4662525,18356398,0,0,0,13432080.999999899,3264660,19807991,6879168.2710539196,89961,76468.339292070101]
[661,"Holstebro",25.5,2988118,11718110,0,0,0,7191322,2123995,12506848,4513046.0920597399,59036,76445.6618344694]
[665,"Lemvig",25.46,1081844,4249191,0,0,0,1652745,1745424,4469164,1531134.7556383701,18966,80730.504884444701]
[671,"Struer",25.3,1053114,4162506,0,0,0,1842411,1016259,4379112,1694125.1723956501,20458,82809.911643154599]
[706,"Syddjurs",25.9,2318871,8953170,0,0,0,8948429,2170728,9920090,3332956.5522376001,44283,75264.922255438796]
[707,"Norddjurs",26,1907882,7338008,0,0,0,3821217,2386639,7795841,3106547.4542061002,36760,84508.907894616699]
[710,"Favrskov",25.6999999999999,2703238,10518436,0,0,0,7989965,2191703,11389592,3551357.6601451999,49531,71699.696354711195]
[727,"Odder",25.099999999999898,1242234,4949139,0,0,0,5497834,1102629,5536094,1825532.0905637201,24079,75814.2817626865]
[730,"Randers",25.8,5112442,19815667,0,0,0,11907884,2946032,21104136,8219089.1722647604,100609,81693.379044268004]
[740,"Silkeborg",25.5,5406773,21203031,0,0,0,19681190,2166902,23249414,7536792.0868324703,102218,73732.533280170494]
[741,"Samsø",25.9,196605,759093,0,0,0,727359,429032.99999999901,845463,300344.12709488202,3711,80933.475369141001]
[746,"Skanderborg",26,3823337,14705142,0,0,0,13126073,1510535,16071957.999999899,4642663.3180485303,65700,70664.586271667198]
[751,"Århus",24.52,19034881,77630020,0,0,0,81700610,1522462,85894944,27162386.665035799,370598,73293.397873263806]
[756,"Ikast-Brande",25.099999999999898,2089623,8325191,0,0,0,5476466,1591987,8925060,3336314.8402926498,42953,77673.616285070893]
[760,"Ringkøbing-Skjern",25,2841633,11366532,0,0,0,8745841,2674415,12328578,4390092.3305687401,56025,78359.523972668307]
[766,"Hedensted",25.52,2554427,10009510,0,0,0,6531983,1030993.99999999,10698282,3545605.8308789302,47899,74022.543912794194]
[773,"Morsø",25.8,1008852,3910279,0,0,0,1367330,719537.99999999895,4069964,1672567.1244936399,19617,85261.106412481298]
[779,"Skive",25.5,2321455,9103745,0,0,0,4080944,1304322,9554387,3696826.3976284801,44472,83127.055172434004]
[787,"Thisted",25.5,2181025,8553039,0,0,0,3934916,2797153,9034945,3487008.68517958,42876,81327.751776742007]
[791,"Viborg",25.5,5088153,19953541,0,0,0,12628110,3917169,21344350,7575956.5687599098,97440,77749.964786123906]
[810,"Brønderslev",26.3,1842176,7004471,0,0,0,2846076,1635631,7341098.9999999898,2928361.86327034,36642,79918.177590479303]
[813,"Frederikshavn",26.2,3060558,11681519,0,0,0,8294576,1130515,12550649,4872153.2309839297,58050,83930.288216777597]
[820,"Vesthimmerland",26.3,1921902,7307612,0,0,0,2879913,1689758,7649310,3036156.2334971302,35842,84709.453532088999]
[825,"Læsø",26.3,86186,327703,0,0,0,420354,81868,372504.99999999901,152270.22262839199,1749,87061.305104855695]
[840,"Rebild",25.83,1723372,6671978,0,0,0,3146191,1550720,7036180,2280424.0504473001,31060,73419.962989288499]
[846,"Mariagerfjord",25.9,2188287,8448985,0,0,0,4124930,1594421,8912981,3340164.6701807799,41720,80061.4733983888]
[849,"Jammerbugt",25.6999999999999,1910015,7431965,0,0,0,5988098,1635123,8084625,3023569.86241194,38164,79225.7064881025]
[851,"Aalborg",25.6,11535866,45061977,0,0,0,32441247,2207784,48393121,16933478.4176578,224619,75387.560347334103]
[860,"Hjørring",26.21,3307302,12618474,0,0,0,8009619,2170372,13490950,5166023.0712091196,63277,81641.4032145823]

{"sheet":"Bilag 3","index":3,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Bilagstabel 3: Parametre til statsgaranti \"&aar","v":"Bilagstabel 3: Parametre til statsgaranti 2025"}]
[]
[null,null," Folketal "," Parametre,"]
[null,null,"bloktilskud","udlignings-"]
[null,null,"mv.","procenter"]
[null,null,null,"mv."]
[]
[null,null,"(1)","(2)"]
[]
[null,"01. Statstilskud ordinært                                                     ",79510700,0]
[null,"02. Betinget statstilskud service                                     ",3000000,0,null,null,null,0]
[null,"03. Betinget statstilskud anlæg                                         ",1000000,0]
[null,"04. Andre tilskud                                                                     ",933800,0]
[null,"05. Tilskud ialt (1+2+3+4)                                                   ",84444500,0]
[null,"06. Samlet udskrivningsgrundlag                                         ",1300580098,0]
[null,"07. Beregningsteknisk grundværdi vedr. produkionsjord                                 ",122378947,0]
[null,"08. Indregning vedr. produktionsjord                               ",3767094,3.0782181963282002E-2]
[null,"09. Beregningsteknisk grundværdi vedr. øvrige ejendomme                             ",1183365741,0]
[null,"10. Indregning vedr. øvrige ejendomme                             ",119031783,0.100587484546452]
[null,"11. Samlet beskatningsgrundlag (6+8+10)                         ",1423378975,0]
[null,"12. Samlet udskrivning                                                           ",356905071,0]
[null,"13. Beskatningsniveau (12/11)                                             ",0,0.25074493670949399]
[null,"14. Samlet folketal                                                                 ",5984354,0]
[null,"15. Beskatningsgrundlag pr. indbygger (kroner)           ",237850.06284721801,0]
[null,"16. Grænse vedr. lavt beskatningsgrundlag (kroner)  ",214065.056562496,0.9]
[null,"17. Grænse vedr. højt beskatningsgrundlag (kroner)  ",297312.57855902199,1.25]
[null,"18. Udligningsprocent beskatningsgrundlag (generel) ",0,0.75]
[null,"19. Udligningsprocent lavt beskatningsgrundlag           ",0,0.2]
[null,"20. Udligningsprocent højt beskatningsgrundlag           ",0,0.18]
[null,"21. Overudligningsgrænse  (bruges ikke)                                                     ",0,0.93]
[null,"22. Bund vedr. udskrivningsprocent i overudligning  (bruges ikke)",0,0.23250000000000001]
[null,"23. Nettodrifts- og anlægsudgifter (udgiftsbehov)     ",467172400,0]
[null,"24. Samlet folketal                                                                 ",5984354,0]
[null,"25. Udgiftsbehov pr. indbygger (23/24)  (kroner)        ",78065.635823014396,0]
[null,"26. Udligningsprocent udgiftsbehov (generel)               ",0,0.93]
[null,"27. Udligningsprocent udgiftsbehov over gennemsnit  ",0,0.02]
[null,"28. Samlet tilskud vedr. indvandrer og efterkommer  ",3474000,0]
[null,"29. Samlet bidrag vedr. indvandrer og efterkommer     ",-3474000,0]
[null,"30. Tilskudår",2025,0]
[null,"31. Korrektion vedr. overudligning                                     ",-261720,0]
[null,"32. Finansiering af tillæg vedr. beskatningsgrundlag ",926064,0]
[null,"33. Finansiering af tillæg vedr. udgiftsbehov               ",-247272,0]

{"sheet":"Makro mv.","index":4,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Bilagstabel til validering af kommunenummer og data"]
[null,"Gyldigt ","Kommune navn"]
[null,"komnr"]
[null,"(ok=1)"]
["Bilagstabel 1",{"$f":"IF((TYPE(VLOOKUP(knr,Bilagtab1,2,FALSE)))=16,0,1)","v":0},{"$f":"IF(B5=1,VLOOKUP(knr,Bilagtab1,2),0)","v":0}]
["Bilagstabel 2",{"$f":"IF((TYPE(VLOOKUP(knr,Bilagtab2,2,FALSE)))=16,0,1)","v":0},{"$f":"IF(B6=1,VLOOKUP(knr,Bilagtab2,2),0)","v":0}]
["OK bilag 1 og 2",{"$f":"IF(2=B5+B6,1,0)","v":0}]
["OK som Primkommune",{"$f":"IF(AND(1=B7,C8>0),1,0)","v":0},{"$f":"IF(B7=1,VLOOKUP(knr,Bilagtab1,1),\"xx\")","v":"xx"}]
[]
["Tilskudsår:/ AAR",{"$f":"TEXT('Bilag 3'!C39,0)","v":"2025"}]
[]
[null,"kom"]
["Kommunen/amtes  data er udfyldt",{"$f":"IF(4=SUM(B14:B17),1,0)","v":0}]
[{"$f":"\"1.01 Budgetteret indkomstskat \"&aar","v":"1.01 Budgetteret indkomstskat 2025"},{"$f":"IF(0<>+Selvbudgettering!F24,1,0)","v":0}]
[{"$f":"\"1.02 Udskrivningsprocent \"&aar","v":"1.02 Udskrivningsprocent 2025"},{"$f":"IF(0<>+Selvbudgettering!F25,1,0)","v":0}]
[{"$f":"\"1.03 Grundværdier/grundskyld \"&aar","v":"1.03 Grundværdier/grundskyld 2025"},{"$f":"IF(0<>+Selvbudgettering!F26,1,0)","v":1}]
[{"$f":"\"1.05 Skønnet folketal pr. 1. janual \"&aar","v":"1.05 Skønnet folketal pr. 1. janual 2025"},{"$f":"IF(0<>+Selvbudgettering!F28,1,0)","v":0}]
[]
["Kommunens data er udfyldt og komnr ok",{"$f":"IF(+B13+B8=2,1,0)","v":0}]